1 link tagged with all of: dbt + semantic layer + text to sql + mcp + data analytics
Click any tag below to further narrow down your results
Links
SLayer is an open-source Python semantic layer that sits on top of a data warehouse so AI agents and people can query metrics without writing SQL by hand. You define a column like revenue once, then query it with expressions such as avg(revenue) or time_shift(sum(revenue), -1, 'year').
- Unlike traditional BI semantic layers, which need every metric and aggregation predefined, SLayer lets agents combine metrics, apply transforms like time shifts, and change aggregations on the fly.
- It handles read-only database connectivity, SQL generation, and row-level security, so the LLM doesn't have to write raw SQL.
- It exposes the same definitions over MCP, REST, CLI, Python, Flight SQL, and a Postgres-style SQL API, and imports configs from dbt, Cube, and Ossie.
- Install is via uv, and it can be added to Claude Code as an MCP server with a demo Jaffle Shop database for a quick start. It sends aggregated usage stats once a day unless you opt out.